Computer science Lesson Plan
Class: 6th to 8th - Lesson:2.2.1 Application of Spreadsheet

Purpose: Students should learn the properties of cells in a spreadsheet.

No. of Classes

Two or three classes (Teacher's decision).

Material Required

Open office (Spreadsheet).

Curriculum Content
  • 3.3.1) Cell
  • 3.3.2) Row
  • 3.3.3) Column
  • 3.3.4) Sheet
  • 3.3.5) Insert new sheet
  • 3.3.6) Cell properties

    • Prior knowledge

    Students should know about Text documents clearly.

    Exercise

    Exercise:1


    1. Change the cell color of the following cells as specified: D13 to Green, G18 to Red, and J7 to Violet.

    Exercise:2


    2. Add a new sheet after sheet 1 and change the sheet name.

    Exercise:3


    3. Find the cell addresses of the cells marked in the below screenshot:

    No Image

    Solution


  • Link to view the solution video for excercise-1,excercise-2,excercise-3.

    • Teacher's Instruction
    1. Teachers should teach the basic operations by using a spreadsheet before giving any exercise.
    2. Teachers should ensure that the Students understand how to insert a new sheet, how to move the sheets before or after another sheet and also how to rename sheets
    3. Teachers can allow students to complete the exercise in a group.